Análisis Exploratorio de Datos

Dataset statistics

Number of variables	29
Number of observations	15712
Missing cells	106947
Missing cells (%)	23.5%
Duplicate rows	20
Duplicate rows (%)	0.1%
Total size in memory	22.4 MiB
Average record size in memory	1.5 KiB

Variable types

Numeric	8
DateTime	5
Categorical	6
Text	8
Unsupported	2

Alerts

`Check-out` has constant value "2024-08-24 11:00:00"	Constant
Dataset has 20 (0.1%) duplicate rows	Duplicates
`Adelanto ya pagado` is highly overall correlated with `Comisión incluida` and 2 other fields	High correlation
`Adultos` is highly overall correlated with `Numero_Huespedes` and 2 other fields	High correlation
`Apartamento` is highly overall correlated with `Pago por adelantado`	High correlation
`Comisión incluida` is highly overall correlated with `Adelanto ya pagado` and 2 other fields	High correlation
`Estado` is highly overall correlated with `Pago por adelantado`	High correlation
`Niños` is highly overall correlated with `Pago por adelantado`	High correlation
`Numero_Huespedes` is highly overall correlated with `Adultos` and 2 other fields	High correlation
`Numero_Reserva` is highly overall correlated with `Adelanto ya pagado` and 2 other fields	High correlation
`Número de noches` is highly overall correlated with `Comisión incluida` and 2 other fields	High correlation
`Pagado` is highly overall correlated with `Adultos` and 3 other fields	High correlation
`Pago por adelantado` is highly overall correlated with `Adelanto ya pagado` and 9 other fields	High correlation
`Portal de reserva` is highly overall correlated with `Numero_Reserva` and 2 other fields	High correlation
`Posición` is highly overall correlated with `Numero_Reserva`	High correlation
`Precio` is highly overall correlated with `Comisión incluida` and 2 other fields	High correlation
`Adelanto ya pagado` is highly imbalanced (99.6%)	Imbalance
`Estado` is highly imbalanced (67.0%)	Imbalance
`Huésped` has 1375 (8.8%) missing values	Missing
`Email` has 4803 (30.6%) missing values	Missing
`Teléfono` has 2568 (16.3%) missing values	Missing
`Dirección` has 15712 (100.0%) missing values	Missing
`Check-in` has 4759 (30.3%) missing values	Missing
`Check-out` has 4857 (30.9%) missing values	Missing
`Notas` has 2272 (14.5%) missing values	Missing
`Precio` has 1469 (9.3%) missing values	Missing
`Detalles de precios` has 3063 (19.5%) missing values	Missing
`Comisión incluida` has 3075 (19.6%) missing values	Missing
`City tax` has 15712 (100.0%) missing values	Missing
`Pago por adelantado` has 15708 (> 99.9%) missing values	Missing
`Nota para colaboradores` has 15703 (99.9%) missing values	Missing
`Numero_Reserva` has 5285 (33.6%) missing values	Missing
`Mensaje_Huesped` has 5293 (33.7%) missing values	Missing
`BOOKING_NOTE` has 5293 (33.7%) missing values	Missing
`Número de noches` is highly skewed (γ1 = 118.2859681)	Skewed
`Dirección` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`City tax` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`Adultos` has 2444 (15.6%) zeros	Zeros
`Niños` has 12790 (81.4%) zeros	Zeros
`Numero_Huespedes` has 2442 (15.5%) zeros	Zeros

Reproduction

Analysis started	2024-08-24 21:42:39.367197
Analysis finished	2024-08-24 21:45:01.522962
Duration	2 minutes and 22.16 seconds
Software version	ydata-profiling vv4.9.0
Download configuration	config.json

Posición
Real number (ℝ)

HIGH CORRELATION

Distinct	15692
Distinct (%)	99.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	41865996

Minimum	15390136
Maximum	69854666
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	122.9 KiB

Quantile statistics

Minimum	15390136
5-th percentile	19849936
Q1	29516090
median	41444873
Q3	53547937
95-th percentile	66463759
Maximum	69854666
Range	54464530
Interquartile range (IQR)	24031847

Descriptive statistics

Standard deviation	14579774
Coefficient of variation (CV)	0.3482486
Kurtosis	-1.0654767
Mean	41865996
Median Absolute Deviation (MAD)	11998268
Skewness	0.11885661
Sum	6.5779852 × 10¹¹
Variance	2.1256982 × 10¹⁴
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
50757695	2	< 0.1%
38091838	2	< 0.1%
31968127	2	< 0.1%
49003082	2	< 0.1%
32169718	2	< 0.1%
49378100	2	< 0.1%
50677661	2	< 0.1%
50878493	2	< 0.1%
50895260	2	< 0.1%
29995319	2	< 0.1%
Other values (15682)	15692	99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
15390136	1	< 0.1%
15463501	1	< 0.1%
15776323	1	< 0.1%
15918979	1	< 0.1%
16641582	1	< 0.1%
16811706	1	< 0.1%
16912662	1	< 0.1%
16982857	1	< 0.1%
16993282	1	< 0.1%
16993297	1	< 0.1%

Value	Count	Frequency (%)
69854666	1	< 0.1%
69849111	1	< 0.1%
69847911	1	< 0.1%
69843366	1	< 0.1%
69840491	1	< 0.1%
69840476	1	< 0.1%
69838566	1	< 0.1%
69834011	1	< 0.1%
69825606	1	< 0.1%
69818721	1	< 0.1%

Llegada
Date

Distinct	1024
Distinct (%)	6.5%
Missing	0
Missing (%)	0.0%
Memory size	122.9 KiB

Minimum	2021-12-19 00:00:00
Maximum	2024-12-11 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

Salida
Date

Distinct	1023
Distinct (%)	6.5%
Missing	0
Missing (%)	0.0%
Memory size	122.9 KiB

Minimum	2022-01-02 00:00:00
Maximum	2028-07-31 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

Apartamento
Categorical

HIGH CORRELATION

Distinct	41
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	1.0 MiB

H BMA PRAGA	734
HD BRUNO	713
H BMA BERLIN	710
H - BUA 3P	697
H - BUA 4P	685
Other values (36)	12173

Length

Max length	21
Median length	16
Mean length	10.908923
Min length	8

Characters and Unicode

Total characters	171401
Distinct characters	33
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	HD OLIVIA
2nd row	HD FIDEL
3rd row	HD ALEJANDRA
4th row	H BMA LISBOA
5th row	HD OLIVIA

Common Values

Value	Count	Frequency (%)
H BMA PRAGA	734	4.7%
HD BRUNO	713	4.5%
H BMA BERLIN	710	4.5%
H - BUA 3P	697	4.4%
H - BUA 4P	685	4.4%
HD ELENA	638	4.1%
H BMA AMSTERDAM	637	4.1%
H BMA MONACO	625	4.0%
H BMA OSLO	623	4.0%
HD CELESTE	600	3.8%
Other values (31)	9050	57.6%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
h	7270	17.9%
bma	5788	14.3%
hd	5373	13.2%
	1482	3.7%
bua	1482	3.7%
hg0	1362	3.4%
hg1	975	2.4%
praga	734	1.8%
bruno	713	1.8%
berlin	710	1.7%
Other values (41)	14700	36.2%

Most occurring characters

Value	Count	Frequency (%)
	24877	14.5%
A	23487	13.7%
H	17721	10.3%
B	10659	6.2%
D	9603	5.6%
E	8425	4.9%
M	8323	4.9%
R	8219	4.8%
I	7818	4.6%
O	7197	4.2%
Other values (23)	45072	26.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	171401	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	24877	14.5%
A	23487	13.7%
H	17721	10.3%
B	10659	6.2%
D	9603	5.6%
E	8425	4.9%
M	8323	4.9%
R	8219	4.8%
I	7818	4.6%
O	7197	4.2%
Other values (23)	45072	26.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	171401	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	24877	14.5%
A	23487	13.7%
H	17721	10.3%
B	10659	6.2%
D	9603	5.6%
E	8425	4.9%
M	8323	4.9%
R	8219	4.8%
I	7818	4.6%
O	7197	4.2%
Other values (23)	45072	26.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	171401	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	24877	14.5%
A	23487	13.7%
H	17721	10.3%
B	10659	6.2%
D	9603	5.6%
E	8425	4.9%
M	8323	4.9%
R	8219	4.8%
I	7818	4.6%
O	7197	4.2%
Other values (23)	45072	26.3%

Huésped
Text

MISSING

Distinct	12201
Distinct (%)	85.1%
Missing	1375
Missing (%)	8.8%
Memory size	1.2 MiB

Length

Max length	127
Median length	63
Mean length	16.398131
Min length	1

Characters and Unicode

Total characters	235100
Distinct characters	241
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	11300 ?
Unique (%)	78.8%

Sample

1st row	Leticia Isla
2nd row	Rodri Gamboa
3rd row	luis
4th row	NATHAN benony
5th row	Dario

Value	Count	Frequency (%)
de	338	1.0%
maria	307	0.9%
garcia	256	0.7%
jose	229	0.7%
rodriguez	180	0.5%
juan	172	0.5%
javier	159	0.5%
martinez	154	0.4%
ana	153	0.4%
amplio	153	0.4%
Other values (12026)	32730	94.0%

Most occurring characters

Value	Count	Frequency (%)
a	26695	11.4%
	20561	8.7%
e	18914	8.0%
r	16109	6.9%
i	14381	6.1%
o	13819	5.9%
n	13444	5.7%
l	10297	4.4%
s	7222	3.1%
t	5901	2.5%
Other values (231)	87757	37.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	235100	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	26695	11.4%
	20561	8.7%
e	18914	8.0%
r	16109	6.9%
i	14381	6.1%
o	13819	5.9%
n	13444	5.7%
l	10297	4.4%
s	7222	3.1%
t	5901	2.5%
Other values (231)	87757	37.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	235100	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	26695	11.4%
	20561	8.7%
e	18914	8.0%
r	16109	6.9%
i	14381	6.1%
o	13819	5.9%
n	13444	5.7%
l	10297	4.4%
s	7222	3.1%
t	5901	2.5%
Other values (231)	87757	37.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	235100	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	26695	11.4%
	20561	8.7%
e	18914	8.0%
r	16109	6.9%
i	14381	6.1%
o	13819	5.9%
n	13444	5.7%
l	10297	4.4%
s	7222	3.1%
t	5901	2.5%
Other values (231)	87757	37.3%

Portal de reserva
Categorical

HIGH CORRELATION

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.0 MiB

Booking.com	10439
Airbnb	2223
Reserva directa	1419
Cerrar fechas (bloqueo)	1326
Página web	305

Length

Max length	23
Median length	11
Mean length	11.647149
Min length	6

Characters and Unicode

Total characters	183000
Distinct characters	31
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Cerrar fechas (bloqueo)
2nd row	Cerrar fechas (bloqueo)
3rd row	Cerrar fechas (bloqueo)
4th row	Cerrar fechas (bloqueo)
5th row	Cerrar fechas (bloqueo)

Common Values

Value	Count	Frequency (%)
Booking.com	10439	66.4%
Airbnb	2223	14.1%
Reserva directa	1419	9.0%
Cerrar fechas (bloqueo)	1326	8.4%
Página web	305	1.9%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
booking.com	10439	52.0%
airbnb	2223	11.1%
reserva	1419	7.1%
directa	1419	7.1%
cerrar	1326	6.6%
fechas	1326	6.6%
bloqueo	1326	6.6%
página	305	1.5%
web	305	1.5%

Most occurring characters

Value	Count	Frequency (%)
o	33969	18.6%
i	14386	7.9%
c	13184	7.2%
n	12967	7.1%
g	10744	5.9%
B	10439	5.7%
k	10439	5.7%
.	10439	5.7%
m	10439	5.7%
r	9039	4.9%
Other values (21)	46955	25.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	183000	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
o	33969	18.6%
i	14386	7.9%
c	13184	7.2%
n	12967	7.1%
g	10744	5.9%
B	10439	5.7%
k	10439	5.7%
.	10439	5.7%
m	10439	5.7%
r	9039	4.9%
Other values (21)	46955	25.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	183000	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
o	33969	18.6%
i	14386	7.9%
c	13184	7.2%
n	12967	7.1%
g	10744	5.9%
B	10439	5.7%
k	10439	5.7%
.	10439	5.7%
m	10439	5.7%
r	9039	4.9%
Other values (21)	46955	25.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	183000	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
o	33969	18.6%
i	14386	7.9%
c	13184	7.2%
n	12967	7.1%
g	10744	5.9%
B	10439	5.7%
k	10439	5.7%
.	10439	5.7%
m	10439	5.7%
r	9039	4.9%
Other values (21)	46955	25.7%

Creado
Date

Distinct	14803
Distinct (%)	94.2%
Missing	0
Missing (%)	0.0%
Memory size	122.9 KiB

Minimum	2021-02-12 11:22:00
Maximum	2024-12-08 23:16:00

Histogram

Histogram with fixed size bins (bins=50)

Email
Text

MISSING

Distinct	10373
Distinct (%)	95.1%
Missing	4803
Missing (%)	30.6%
Memory size	1.1 MiB

Length

Max length	40
Median length	31
Mean length	30.558988
Min length	12

Characters and Unicode

Total characters	333368
Distinct characters	62
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	10008 ?
Unique (%)	91.7%

Sample

1st row	lisla.593122@guest.booking.com
2nd row	rgambo.386041@guest.booking.com
3rd row	nbenon.480362@guest.booking.com
4th row	aaquit.901533@guest.booking.com
5th row	hlee.108965@guest.booking.com

Value	Count	Frequency (%)
marycasadocarreto@gmail.com	13	0.1%
officialbryan09@aol.com	12	0.1%
institucional@castellersdevilafranca.cat	10	0.1%
carabalil@aol.com	10	0.1%
jvila.937171@guest.booking.com	8	0.1%
lsanz@paulmitchell.es	8	0.1%
yaling0404068@gmail.com	7	0.1%
ksaman.612410@guest.booking.com	6	0.1%
juanjomaruno@gmail.com	6	0.1%
jm.barquin@protiopower.com	6	0.1%
Other values (10362)	10823	99.2%

Most occurring characters

Value	Count	Frequency (%)
o	36144	10.8%
.	31987	9.6%
g	23229	7.0%
e	16231	4.9%
i	15104	4.5%
m	14642	4.4%
n	14067	4.2%
s	13868	4.2%
c	13815	4.1%
t	12751	3.8%
Other values (52)	141530	42.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	333368	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
o	36144	10.8%
.	31987	9.6%
g	23229	7.0%
e	16231	4.9%
i	15104	4.5%
m	14642	4.4%
n	14067	4.2%
s	13868	4.2%
c	13815	4.1%
t	12751	3.8%
Other values (52)	141530	42.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	333368	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
o	36144	10.8%
.	31987	9.6%
g	23229	7.0%
e	16231	4.9%
i	15104	4.5%
m	14642	4.4%
n	14067	4.2%
s	13868	4.2%
c	13815	4.1%
t	12751	3.8%
Other values (52)	141530	42.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	333368	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
o	36144	10.8%
.	31987	9.6%
g	23229	7.0%
e	16231	4.9%
i	15104	4.5%
m	14642	4.4%
n	14067	4.2%
s	13868	4.2%
c	13815	4.1%
t	12751	3.8%
Other values (52)	141530	42.5%

Teléfono
Text

MISSING

Distinct	11601
Distinct (%)	88.3%
Missing	2568
Missing (%)	16.3%
Memory size	1000.4 KiB

Length

Max length	20
Median length	16
Mean length	14.67605
Min length	9

Characters and Unicode

Total characters	192902
Distinct characters	12
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	10713 ?
Unique (%)	81.5%

Sample

1st row	+34 656 73 69 43
2nd row	+34 662 96 91 70
3rd row	+33 6 17 12 54 98
4th row	+34 670 90 62 94
5th row	+82 421915930214

Value	Count	Frequency (%)
34	7159	14.6%
33	1126	2.3%
6	928	1.9%
49	525	1.1%
31	510	1.0%
39	505	1.0%
44	499	1.0%
32	331	0.7%
70	315	0.6%
48	309	0.6%
Other values (6138)	36907	75.1%

Most occurring characters

Value	Count	Frequency (%)
	35972	18.6%
3	23286	12.1%
6	21280	11.0%
4	20387	10.6%
7	12564	6.5%
1	12028	6.2%
9	11926	6.2%
5	11833	6.1%
2	11328	5.9%
0	11082	5.7%
Other values (2)	21216	11.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	192902	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	35972	18.6%
3	23286	12.1%
6	21280	11.0%
4	20387	10.6%
7	12564	6.5%
1	12028	6.2%
9	11926	6.2%
5	11833	6.1%
2	11328	5.9%
0	11082	5.7%
Other values (2)	21216	11.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	192902	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	35972	18.6%
3	23286	12.1%
6	21280	11.0%
4	20387	10.6%
7	12564	6.5%
1	12028	6.2%
9	11926	6.2%
5	11833	6.1%
2	11328	5.9%
0	11082	5.7%
Other values (2)	21216	11.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	192902	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	35972	18.6%
3	23286	12.1%
6	21280	11.0%
4	20387	10.6%
7	12564	6.5%
1	12028	6.2%
9	11926	6.2%
5	11833	6.1%
2	11328	5.9%
0	11082	5.7%
Other values (2)	21216	11.0%

Dirección
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	15712
Missing (%)	100.0%
Memory size	122.9 KiB

Adultos
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	9
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.2334521

Minimum	0
Maximum	8
Zeros	2444
Zeros (%)	15.6%
Negative	0
Negative (%)	0.0%
Memory size	122.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	2
Q3	3
95-th percentile	5
Maximum	8
Range	8
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	1.5834759
Coefficient of variation (CV)	0.70898135
Kurtosis	0.89371826
Mean	2.2334521
Median Absolute Deviation (MAD)	1
Skewness	0.78889935
Sum	35092
Variance	2.5073959
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=9)

Value	Count	Frequency (%)
2	6114	38.9%
0	2444	15.6%
3	2098	13.4%
1	1958	12.5%
4	1903	12.1%
5	528	3.4%
6	389	2.5%
7	198	1.3%
8	80	0.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	2444	15.6%
1	1958	12.5%
2	6114	38.9%
3	2098	13.4%
4	1903	12.1%
5	528	3.4%
6	389	2.5%
7	198	1.3%
8	80	0.5%

Value	Count	Frequency (%)
8	80	0.5%
7	198	1.3%
6	389	2.5%
5	528	3.4%
4	1903	12.1%
3	2098	13.4%
2	6114	38.9%
1	1958	12.5%
0	2444	15.6%

Niños
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	8
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.32764766

Minimum	0
Maximum	7
Zeros	12790
Zeros (%)	81.4%
Negative	0
Negative (%)	0.0%
Memory size	122.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	2
Maximum	7
Range	7
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.75253459
Coefficient of variation (CV)	2.29678
Kurtosis	5.4976049
Mean	0.32764766
Median Absolute Deviation (MAD)	0
Skewness	2.3708238
Sum	5148
Variance	0.56630831
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=8)

Value	Count	Frequency (%)
0	12790	81.4%
2	1503	9.6%
1	1093	7.0%
3	272	1.7%
4	43	0.3%
5	6	< 0.1%
6	4	< 0.1%
7	1	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	12790	81.4%
1	1093	7.0%
2	1503	9.6%
3	272	1.7%
4	43	0.3%
5	6	< 0.1%
6	4	< 0.1%
7	1	< 0.1%

Value	Count	Frequency (%)
7	1	< 0.1%
6	4	< 0.1%
5	6	< 0.1%
4	43	0.3%
3	272	1.7%
2	1503	9.6%
1	1093	7.0%
0	12790	81.4%

Check-in
Date

MISSING

Distinct	16
Distinct (%)	0.1%
Missing	4759
Missing (%)	30.3%
Memory size	122.9 KiB

Minimum	2024-08-24 00:00:00
Maximum	2024-08-24 23:30:00

Histogram

Histogram with fixed size bins (bins=16)

Check-out
Date

CONSTANT MISSING

Distinct	1
Distinct (%)	< 0.1%
Missing	4857
Missing (%)	30.9%
Memory size	122.9 KiB

Minimum	2024-08-24 11:00:00
Maximum	2024-08-24 11:00:00

Histogram

Histogram with fixed size bins (bins=1)

Notas
Text

MISSING

Distinct	12902
Distinct (%)	96.0%
Missing	2272
Missing (%)	14.5%
Memory size	7.5 MiB

Length

Max length	1115
Median length	921
Mean length	246.22515
Min length	3

Characters and Unicode

Total characters	3309266
Distinct characters	271
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	12529 ?
Unique (%)	93.2%

Sample

1st row	Número de reserva: 3509184945 Mensaje del huésped: THIS RESERVATION HAS BEEN PRE-PAID BOOKING NOTE : Payment charge is EUR 2.5839 Más información: booker_is_genius Pago por adelantado: 234.90EUR
2nd row	Número de reserva: 3677697588 Mensaje del huésped: THIS RESERVATION HAS BEEN PRE-PAID Approximate time of arrival: between 14:00 and 15:00 BOOKING NOTE : Payment charge is EUR 1.045 Más información: booker_is_genius Pago por adelantado: 95.00EUR
3rd row	Número de reserva: 2331981900 Mensaje del huésped: THIS RESERVATION HAS BEEN PRE-PAID Approximate time of arrival: between 17:00 and 18:00 BOOKING NOTE : Payment charge is EUR 2.695 Más información: booker_is_genius Pago por adelantado: 245.00EUR
4th row	Trjeta 28.12
5th row	Número de reserva: 3390950867 Mensaje del huésped: THIS RESERVATION HAS BEEN PRE-PAID BOOKING NOTE : Payment charge is EUR 2.211 Más información: booker_is_genius Pago por adelantado: 201.00EUR

Value	Count	Frequency (%)
	33710	7.4%
de	15271	3.3%
reserva	14363	3.1%
del	14235	3.1%
número	12662	2.8%
huésped	12634	2.8%
por	11125	2.4%
más	10652	2.3%
has	10649	2.3%
is	10619	2.3%
Other values (26638)	310910	68.1%

Most occurring characters

Value	Count	Frequency (%)
	395960	12.0%
e	239121	7.2%
a	181972	5.5%
o	132880	4.0%
r	127744	3.9%
n	122691	3.7%
s	120443	3.6%
i	114242	3.5%
d	91393	2.8%
E	86974	2.6%
Other values (261)	1695846	51.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	3309266	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	395960	12.0%
e	239121	7.2%
a	181972	5.5%
o	132880	4.0%
r	127744	3.9%
n	122691	3.7%
s	120443	3.6%
i	114242	3.5%
d	91393	2.8%
E	86974	2.6%
Other values (261)	1695846	51.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	3309266	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	395960	12.0%
e	239121	7.2%
a	181972	5.5%
o	132880	4.0%
r	127744	3.9%
n	122691	3.7%
s	120443	3.6%
i	114242	3.5%
d	91393	2.8%
E	86974	2.6%
Other values (261)	1695846	51.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	3309266	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	395960	12.0%
e	239121	7.2%
a	181972	5.5%
o	132880	4.0%
r	127744	3.9%
n	122691	3.7%
s	120443	3.6%
i	114242	3.5%
d	91393	2.8%
E	86974	2.6%
Other values (261)	1695846	51.2%

Precio
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	2520
Distinct (%)	17.7%
Missing	1469
Missing (%)	9.3%
Infinite	0
Infinite (%)	0.0%
Mean	230.485

Minimum	1.15
Maximum	7847.6
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	122.9 KiB

Quantile statistics

Minimum	1.15
5-th percentile	45
Q1	81.95
median	148
Q3	272
95-th percentile	674
Maximum	7847.6
Range	7846.45
Interquartile range (IQR)	190.05

Descriptive statistics

Standard deviation	292.40293
Coefficient of variation (CV)	1.2686419
Kurtosis	129.08129
Mean	230.485
Median Absolute Deviation (MAD)	77
Skewness	7.743219
Sum	3282797.8
Variance	85499.472
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
65	280	1.8%
20	259	1.6%
71	220	1.4%
77	206	1.3%
59	163	1.0%
83	155	1.0%
60	141	0.9%
53.1	135	0.9%
40	132	0.8%
95	128	0.8%
Other values (2510)	12424	79.1%
(Missing)	1469	9.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1.15	1	< 0.1%
2.25	1	< 0.1%
3	1	< 0.1%
8.91	1	< 0.1%
10	27	0.2%
11	1	< 0.1%
13	1	< 0.1%
13.5	1	< 0.1%
15	25	0.2%
17.25	1	< 0.1%

Value	Count	Frequency (%)
7847.6	2	< 0.1%
7330	1	< 0.1%
5785	1	< 0.1%
5595.25	1	< 0.1%
4097	1	< 0.1%
3886	1	< 0.1%
3800	1	< 0.1%
3738.2	1	< 0.1%
3630	1	< 0.1%
3600	1	< 0.1%

Detalles de precios
Text

MISSING

Distinct	3735
Distinct (%)	29.5%
Missing	3063
Missing (%)	19.5%
Memory size	1.1 MiB

Length

Max length	183
Median length	123
Mean length	26.488971
Min length	11

Characters and Unicode

Total characters	335059
Distinct characters	40
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2083 ?
Unique (%)	16.5%

Sample

1st row	TVA - EUR 21.35
2nd row	TVA - EUR 8.64
3rd row	TVA - EUR 22.27
4th row	IVA - EUR 18.27
5th row	TVA - EUR 20.27

Value	Count	Frequency (%)
	16463	22.2%
eur	16463	22.2%
iva	5329	7.2%
tva	5097	6.9%
cancellation	4448	6.0%
fee	2224	3.0%
host	2224	3.0%
payout	2224	3.0%
security	1585	2.1%
price	1585	2.1%
Other values (2963)	16475	22.2%

Most occurring characters

Value	Count	Frequency (%)
	57654	17.2%
-	16463	4.9%
E	16463	4.9%
U	16463	4.9%
R	16463	4.9%
.	13870	4.1%
e	12066	3.6%
a	11128	3.3%
1	10765	3.2%
t	10489	3.1%
Other values (30)	153235	45.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	335059	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	57654	17.2%
-	16463	4.9%
E	16463	4.9%
U	16463	4.9%
R	16463	4.9%
.	13870	4.1%
e	12066	3.6%
a	11128	3.3%
1	10765	3.2%
t	10489	3.1%
Other values (30)	153235	45.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	335059	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	57654	17.2%
-	16463	4.9%
E	16463	4.9%
U	16463	4.9%
R	16463	4.9%
.	13870	4.1%
e	12066	3.6%
a	11128	3.3%
1	10765	3.2%
t	10489	3.1%
Other values (30)	153235	45.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	335059	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	57654	17.2%
-	16463	4.9%
E	16463	4.9%
U	16463	4.9%
R	16463	4.9%
.	13870	4.1%
e	12066	3.6%
a	11128	3.3%
1	10765	3.2%
t	10489	3.1%
Other values (30)	153235	45.7%

Comisión incluida
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	2229
Distinct (%)	17.6%
Missing	3075
Missing (%)	19.6%
Infinite	0
Infinite (%)	0.0%
Mean	35.101689

Minimum	0.17
Maximum	867.75
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	122.9 KiB

Quantile statistics

Minimum	0.17
5-th percentile	8.1
Q1	13.35
median	23.1
Q3	42.04
95-th percentile	99.9
Maximum	867.75
Range	867.58
Interquartile range (IQR)	28.69

Descriptive statistics

Standard deviation	38.59222
Coefficient of variation (CV)	1.0994406
Kurtosis	60.283014
Mean	35.101689
Median Absolute Deviation (MAD)	11.55
Skewness	5.3086587
Sum	443580.04
Variance	1489.3595
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
9.75	264	1.7%
10.65	224	1.4%
11.55	197	1.3%
12.45	162	1.0%
8.85	160	1.0%
7.96	135	0.9%
21.3	126	0.8%
14.25	125	0.8%
8.78	122	0.8%
17.55	111	0.7%
Other values (2219)	11011	70.1%
(Missing)	3075	19.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.17	1	< 0.1%
0.34	1	< 0.1%
0.45	1	< 0.1%
1.34	1	< 0.1%
1.5	1	< 0.1%
1.65	1	< 0.1%
1.95	1	< 0.1%
2.02	1	< 0.1%
2.25	1	< 0.1%
2.59	1	< 0.1%

Value	Count	Frequency (%)
867.75	1	< 0.1%
839.29	1	< 0.1%
614.55	1	< 0.1%
582.9	1	< 0.1%
560.73	1	< 0.1%
502.95	1	< 0.1%
492	1	< 0.1%
457.5	2	< 0.1%
445.45	1	< 0.1%
443.27	1	< 0.1%

City tax
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	15712
Missing (%)	100.0%
Memory size	122.9 KiB

Pagado
Categorical

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.2 MiB

Sí	11501
No	4211

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	31424
Distinct characters	4
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	No
2nd row	No
3rd row	No
4th row	No
5th row	No

Common Values

Value	Count	Frequency (%)
Sí	11501	73.2%
No	4211	26.8%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
sí	11501	73.2%
no	4211	26.8%

Most occurring characters

Value	Count	Frequency (%)
S	11501	36.6%
í	11501	36.6%
N	4211	13.4%
o	4211	13.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	31424	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
S	11501	36.6%
í	11501	36.6%
N	4211	13.4%
o	4211	13.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	31424	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
S	11501	36.6%
í	11501	36.6%
N	4211	13.4%
o	4211	13.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	31424	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
S	11501	36.6%
í	11501	36.6%
N	4211	13.4%
o	4211	13.4%

Pago por adelantado
Categorical

HIGH CORRELATION MISSING

Distinct	3
Distinct (%)	75.0%
Missing	15708
Missing (%)	> 99.9%
Memory size	859.4 KiB

40.0	2
800.0	1
140.0	1

Length

Max length	5
Median length	4.5
Mean length	4.5
Min length	4

Characters and Unicode

Total characters	18
Distinct characters	5
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2 ?
Unique (%)	50.0%

Sample

1st row	40.0
2nd row	800.0
3rd row	40.0
4th row	140.0

Common Values

Value	Count	Frequency (%)
40.0	2	< 0.1%
800.0	1	< 0.1%
140.0	1	< 0.1%
(Missing)	15708	> 99.9%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
40.0	2	50.0%
800.0	1	25.0%
140.0	1	25.0%

Most occurring characters

Value	Count	Frequency (%)
0	9	50.0%
.	4	22.2%
4	3	16.7%
8	1	5.6%
1	1	5.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	18	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	9	50.0%
.	4	22.2%
4	3	16.7%
8	1	5.6%
1	1	5.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	18	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	9	50.0%
.	4	22.2%
4	3	16.7%
8	1	5.6%
1	1	5.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	18	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	9	50.0%
.	4	22.2%
4	3	16.7%
8	1	5.6%
1	1	5.6%

Adelanto ya pagado
Categorical

HIGH CORRELATION IMBALANCE

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	905.5 KiB

No	15707
Sí	5

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	31424
Distinct characters	4
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	No
2nd row	No
3rd row	No
4th row	No
5th row	No

Common Values

Value	Count	Frequency (%)
No	15707	> 99.9%
Sí	5	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
no	15707	> 99.9%
sí	5	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
N	15707	50.0%
o	15707	50.0%
S	5	< 0.1%
í	5	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	31424	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
N	15707	50.0%
o	15707	50.0%
S	5	< 0.1%
í	5	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	31424	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
N	15707	50.0%
o	15707	50.0%
S	5	< 0.1%
í	5	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	31424	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
N	15707	50.0%
o	15707	50.0%
S	5	< 0.1%
í	5	< 0.1%

Número de noches
Real number (ℝ)

HIGH CORRELATION SKEWED

Distinct	37
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.9168152

Minimum	1
Maximum	1491
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	122.9 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1
Q3	2
95-th percentile	4
Maximum	1491
Range	1490
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	12.117033
Coefficient of variation (CV)	6.3214407
Kurtosis	14520.764
Mean	1.9168152
Median Absolute Deviation (MAD)	0
Skewness	118.28597
Sum	30117
Variance	146.8225
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=37)

Value	Count	Frequency (%)
1	9425	60.0%
2	3572	22.7%
3	1482	9.4%
4	663	4.2%
5	270	1.7%
7	80	0.5%
6	78	0.5%
8	26	0.2%
9	13	0.1%
10	13	0.1%
Other values (27)	90	0.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	9425	60.0%
2	3572	22.7%
3	1482	9.4%
4	663	4.2%
5	270	1.7%
6	78	0.5%
7	80	0.5%
8	26	0.2%
9	13	0.1%
10	13	0.1%

Value	Count	Frequency (%)
1491	1	< 0.1%
112	1	< 0.1%
91	1	< 0.1%
81	1	< 0.1%
62	2	< 0.1%
42	1	< 0.1%
40	2	< 0.1%
33	1	< 0.1%
31	10	0.1%
30	6	< 0.1%

Estado
Categorical

HIGH CORRELATION IMBALANCE

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1012.8 KiB

Reservado	13902
Cancelado	1795
Overbooking	15

Length

Max length	11
Median length	9
Mean length	9.0019094
Min length	9

Characters and Unicode

Total characters	141438
Distinct characters	17
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Reservado
2nd row	Reservado
3rd row	Reservado
4th row	Reservado
5th row	Reservado

Common Values

Value	Count	Frequency (%)
Reservado	13902	88.5%
Cancelado	1795	11.4%
Overbooking	15	0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
reservado	13902	88.5%
cancelado	1795	11.4%
overbooking	15	0.1%

Most occurring characters

Value	Count	Frequency (%)
e	29614	20.9%
a	17492	12.4%
o	15727	11.1%
d	15697	11.1%
r	13917	9.8%
v	13917	9.8%
R	13902	9.8%
s	13902	9.8%
n	1810	1.3%
l	1795	1.3%
Other values (7)	3665	2.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	141438	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	29614	20.9%
a	17492	12.4%
o	15727	11.1%
d	15697	11.1%
r	13917	9.8%
v	13917	9.8%
R	13902	9.8%
s	13902	9.8%
n	1810	1.3%
l	1795	1.3%
Other values (7)	3665	2.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	141438	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	29614	20.9%
a	17492	12.4%
o	15727	11.1%
d	15697	11.1%
r	13917	9.8%
v	13917	9.8%
R	13902	9.8%
s	13902	9.8%
n	1810	1.3%
l	1795	1.3%
Other values (7)	3665	2.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	141438	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	29614	20.9%
a	17492	12.4%
o	15727	11.1%
d	15697	11.1%
r	13917	9.8%
v	13917	9.8%
R	13902	9.8%
s	13902	9.8%
n	1810	1.3%
l	1795	1.3%
Other values (7)	3665	2.6%

Nota para colaboradores
Text

MISSING

Distinct	9
Distinct (%)	100.0%
Missing	15703
Missing (%)	99.9%
Memory size	491.7 KiB

Length

Max length	51
Median length	31
Mean length	22.333333
Min length	13

Characters and Unicode

Total characters	201
Distinct characters	38
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	9 ?
Unique (%)	100.0%

Sample

1st row	Tarjeta el 10
2nd row	Pagado con tarjeta 07-06
3rd row	Reserva hostel navarra adentro
4th row	pagado por tarjeta
5th row	deja a la salida los 45€ registrar su DNI en chekin

Value	Count	Frequency (%)
tarjeta	7	18.9%
el	5	13.5%
pagado	2	5.4%
salida	1	2.7%
28-07	1	2.7%
27-09	1	2.7%
02-10	1	2.7%
chekin	1	2.7%
en	1	2.7%
dni	1	2.7%
Other values (16)	16	43.2%

Most occurring characters

Value	Count	Frequency (%)
a	29	14.4%
	28	13.9%
e	20	10.0%
r	15	7.5%
t	13	6.5%
l	9	4.5%
j	8	4.0%
0	8	4.0%
o	7	3.5%
s	6	3.0%
Other values (28)	58	28.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	201	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	29	14.4%
	28	13.9%
e	20	10.0%
r	15	7.5%
t	13	6.5%
l	9	4.5%
j	8	4.0%
0	8	4.0%
o	7	3.5%
s	6	3.0%
Other values (28)	58	28.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	201	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	29	14.4%
	28	13.9%
e	20	10.0%
r	15	7.5%
t	13	6.5%
l	9	4.5%
j	8	4.0%
0	8	4.0%
o	7	3.5%
s	6	3.0%
Other values (28)	58	28.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	201	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	29	14.4%
	28	13.9%
e	20	10.0%
r	15	7.5%
t	13	6.5%
l	9	4.5%
j	8	4.0%
0	8	4.0%
o	7	3.5%
s	6	3.0%
Other values (28)	58	28.9%

Numero_Reserva
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	10051
Distinct (%)	96.4%
Missing	5285
Missing (%)	33.6%
Infinite	0
Infinite (%)	0.0%
Mean	3.6453499 × 10⁹

Minimum	1.0059188 × 10⁹
Maximum	5.0001592 × 10⁹
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	122.9 KiB

Quantile statistics

Minimum	1.0059188 × 10⁹
5-th percentile	2.2570196 × 10⁹
Q1	2.9378111 × 10⁹
median	3.8202388 × 10⁹
Q3	4.2696162 × 10⁹
95-th percentile	4.8358709 × 10⁹
Maximum	5.0001592 × 10⁹
Range	3.9942404 × 10⁹
Interquartile range (IQR)	1.3318051 × 10⁹

Descriptive statistics

Standard deviation	8.2927551 × 10⁸
Coefficient of variation (CV)	0.22748859
Kurtosis	-0.86882289
Mean	3.6453499 × 10⁹
Median Absolute Deviation (MAD)	6.1502163 × 10⁸
Skewness	-0.36088964
Sum	3.8010064 × 10¹³
Variance	6.8769786 × 10¹⁷
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
4283082648	8	0.1%
4208534781	6	< 0.1%
4242031213	5	< 0.1%
3234695754	5	< 0.1%
4717565131	5	< 0.1%
4122679904	4	< 0.1%
2944693149	4	< 0.1%
3779868996	4	< 0.1%
4102548481	4	< 0.1%
4273851934	4	< 0.1%
Other values (10041)	10378	66.1%
(Missing)	5285	33.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1005918761	1	< 0.1%
1005940672	1	< 0.1%
1007108187	1	< 0.1%
1015466631	1	< 0.1%
1021315351	1	< 0.1%
1021317261	1	< 0.1%
1021389587	1	< 0.1%
1029968432	1	< 0.1%
1062900362	1	< 0.1%
1062942205	1	< 0.1%

Value	Count	Frequency (%)
5000159195	1	< 0.1%
4999865749	1	< 0.1%
4999810028	1	< 0.1%
4999203753	1	< 0.1%
4999049478	1	< 0.1%
4999029286	1	< 0.1%
4998728654	1	< 0.1%
4998674805	1	< 0.1%
4998670026	1	< 0.1%
4998637580	1	< 0.1%

Mensaje_Huesped
Text

MISSING

Distinct	1184
Distinct (%)	11.4%
Missing	5293
Missing (%)	33.7%
Memory size	1.4 MiB

Length

Max length	824
Median length	0
Mean length	32.616182
Min length	0

Characters and Unicode

Total characters	339828
Distinct characters	108
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1107 ?
Unique (%)	10.6%

Sample

1st row
2nd row
3rd row
4th row
5th row

Value	Count	Frequency (%)
and	1223	3.0%
of	1221	3.0%
time	1198	2.9%
arrival	1193	2.9%
between	1192	2.9%
approximate	1188	2.9%
en	900	2.2%
smart	859	2.1%
flex	859	2.1%
de	780	1.9%
Other values (2787)	30689	74.3%

Most occurring characters

Value	Count	Frequency (%)
	38456	11.3%
e	27544	8.1%
a	25766	7.6%
t	19390	5.7%
i	19317	5.7%
n	18796	5.5%
o	17847	5.3%
r	14641	4.3%
s	13779	4.1%
l	11445	3.4%
Other values (98)	132847	39.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	339828	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	38456	11.3%
e	27544	8.1%
a	25766	7.6%
t	19390	5.7%
i	19317	5.7%
n	18796	5.5%
o	17847	5.3%
r	14641	4.3%
s	13779	4.1%
l	11445	3.4%
Other values (98)	132847	39.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	339828	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	38456	11.3%
e	27544	8.1%
a	25766	7.6%
t	19390	5.7%
i	19317	5.7%
n	18796	5.5%
o	17847	5.3%
r	14641	4.3%
s	13779	4.1%
l	11445	3.4%
Other values (98)	132847	39.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	339828	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	38456	11.3%
e	27544	8.1%
a	25766	7.6%
t	19390	5.7%
i	19317	5.7%
n	18796	5.5%
o	17847	5.3%
r	14641	4.3%
s	13779	4.1%
l	11445	3.4%
Other values (98)	132847	39.1%

BOOKING_NOTE
Text

MISSING

Distinct	2254
Distinct (%)	21.6%
Missing	5293
Missing (%)	33.7%
Memory size	1.0 MiB

Length

Max length	30
Median length	27
Mean length	27.455226
Min length	25

Characters and Unicode

Total characters	286056
Distinct characters	28
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1051 ?
Unique (%)	10.1%

Sample

1st row	Payment charge is EUR 2.5839
2nd row	Payment charge is EUR 1.045
3rd row	Payment charge is EUR 2.695
4th row	Payment charge is EUR 2.211
5th row	Payment charge is EUR 2.453

Value	Count	Frequency (%)
payment	10419	20.0%
eur	10419	20.0%
charge	10419	20.0%
is	10419	20.0%
0.715	175	0.3%
0.781	161	0.3%
0.649	156	0.3%
0.5841	136	0.3%
0.6435	121	0.2%
0.847	118	0.2%
Other values (2248)	9552	18.3%

Most occurring characters

Value	Count	Frequency (%)
	41676	14.6%
e	20838	7.3%
a	20838	7.3%
P	10419	3.6%
g	10419	3.6%
.	10419	3.6%
R	10419	3.6%
U	10419	3.6%
s	10419	3.6%
i	10419	3.6%
Other values (18)	129771	45.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	286056	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	41676	14.6%
e	20838	7.3%
a	20838	7.3%
P	10419	3.6%
g	10419	3.6%
.	10419	3.6%
R	10419	3.6%
U	10419	3.6%
s	10419	3.6%
i	10419	3.6%
Other values (18)	129771	45.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	286056	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	41676	14.6%
e	20838	7.3%
a	20838	7.3%
P	10419	3.6%
g	10419	3.6%
.	10419	3.6%
R	10419	3.6%
U	10419	3.6%
s	10419	3.6%
i	10419	3.6%
Other values (18)	129771	45.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	286056	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	41676	14.6%
e	20838	7.3%
a	20838	7.3%
P	10419	3.6%
g	10419	3.6%
.	10419	3.6%
R	10419	3.6%
U	10419	3.6%
s	10419	3.6%
i	10419	3.6%
Other values (18)	129771	45.4%

Numero_Huespedes
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	9
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.5610998

Minimum	0
Maximum	8
Zeros	2442
Zeros (%)	15.5%
Negative	0
Negative (%)	0.0%
Memory size	122.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	2
Q3	4
95-th percentile	6
Maximum	8
Range	8
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	1.7650008
Coefficient of variation (CV)	0.68915737
Kurtosis	-0.031291712
Mean	2.5610998
Median Absolute Deviation (MAD)	1
Skewness	0.45372578
Sum	40240
Variance	3.1152278
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=9)

Value	Count	Frequency (%)
2	4130	26.3%
4	3246	20.7%
0	2442	15.5%
3	2420	15.4%
1	1777	11.3%
5	778	5.0%
6	484	3.1%
7	315	2.0%
8	120	0.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	2442	15.5%
1	1777	11.3%
2	4130	26.3%
3	2420	15.4%
4	3246	20.7%
5	778	5.0%
6	484	3.1%
7	315	2.0%
8	120	0.8%

Value	Count	Frequency (%)
8	120	0.8%
7	315	2.0%
6	484	3.1%
5	778	5.0%
4	3246	20.7%
3	2420	15.4%
2	4130	26.3%
1	1777	11.3%
0	2442	15.5%

Auto

Heatmap
Table

	Adelanto ya pagado	Adultos	Apartamento	Comisión incluida	Estado	Niños	Numero_Huespedes	Numero_Reserva	Número de noches	Pagado	Pago por adelantado	Portal de reserva	Posición	Precio
Adelanto ya pagado	1.000	0.024	0.059	1.000	0.000	0.000	0.024	1.000	0.000	0.024	0.707	0.054	0.034	0.000
Adultos	0.024	1.000	0.329	0.337	0.106	0.061	0.892	-0.021	0.015	0.609	1.000	0.474	0.113	0.415
Apartamento	0.059	0.329	1.000	0.074	0.071	0.111	0.375	0.000	0.078	0.284	1.000	0.395	0.196	0.083
Comisión incluida	1.000	0.337	0.074	1.000	0.069	0.175	0.416	-0.010	0.738	0.026	0.000	0.023	0.050	1.000
Estado	0.000	0.106	0.071	0.069	1.000	0.006	0.104	0.120	0.019	0.125	1.000	0.130	0.031	0.062
Niños	0.000	0.061	0.111	0.175	0.006	1.000	0.467	-0.008	0.024	0.182	1.000	0.122	0.053	0.196
Numero_Huespedes	0.024	0.892	0.375	0.416	0.104	0.467	1.000	-0.026	0.024	0.610	1.000	0.473	0.118	0.475
Numero_Reserva	1.000	-0.021	0.000	-0.010	0.120	-0.008	-0.026	1.000	-0.041	0.188	0.000	1.000	0.802	-0.010
Número de noches	0.000	0.015	0.078	0.738	0.019	0.024	0.024	-0.041	1.000	0.000	1.000	0.021	-0.008	0.677
Pagado	0.024	0.609	0.284	0.026	0.125	0.182	0.610	0.188	0.000	1.000	1.000	0.732	0.482	0.036
Pago por adelantado	0.707	1.000	1.000	0.000	1.000	1.000	1.000	0.000	1.000	1.000	1.000	1.000	0.000	0.707
Portal de reserva	0.054	0.474	0.395	0.023	0.130	0.122	0.473	1.000	0.021	0.732	1.000	1.000	0.150	0.035
Posición	0.034	0.113	0.196	0.050	0.031	0.053	0.118	0.802	-0.008	0.482	0.000	0.150	1.000	0.066
Precio	0.000	0.415	0.083	1.000	0.062	0.196	0.475	-0.010	0.677	0.036	0.707	0.035	0.066	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

First rows
Last rows

	Posición	Llegada	Salida	Apartamento	Huésped	Portal de reserva	Creado	Email	Teléfono	Dirección	Check-in	Check-out	Notas	Precio	Detalles de precios	Comisión incluida	City tax	Pagado	Pago por adelantado	Adelanto ya pagado	Número de noches	Estado	Nota para colaboradores	Numero_Reserva	Mensaje_Huesped	BOOKING_NOTE
0	32518147	2022-12-31	2023-01-01	HD OLIVIA	NaN	Cerrar fechas (bloqueo)	2022-12-31 21:56:00	NaN	NaN	NaN	2024-08-24 16:00:00	2024-08-24 11:00:00	NaN	NaN	NaN	NaN	NaN	No	NaN	No	1	Reservado	NaN	NaN	NaN	NaN
1	32518144	2022-12-31	2023-01-01	HD FIDEL	NaN	Cerrar fechas (bloqueo)	2022-12-31 21:56:00	NaN	NaN	NaN	2024-08-24 16:00:00	2024-08-24 11:00:00	NaN	NaN	NaN	NaN	NaN	No	NaN	No	1	Reservado	NaN	NaN	NaN	NaN
2	32518120	2022-12-31	2023-01-01	HD ALEJANDRA	NaN	Cerrar fechas (bloqueo)	2022-12-31 21:56:00	NaN	NaN	NaN	2024-08-24 16:00:00	2024-08-24 11:00:00	NaN	NaN	NaN	NaN	NaN	No	NaN	No	1	Reservado	NaN	NaN	NaN	NaN
3	32518117	2022-12-31	2023-01-01	H BMA LISBOA	NaN	Cerrar fechas (bloqueo)	2022-12-31 21:55:00	NaN	NaN	NaN	NaT	NaT	NaN	NaN	NaN	NaN	NaN	No	NaN	No	1	Reservado	NaN	NaN	NaN	NaN
4	32489530	2022-12-30	2022-12-31	HD OLIVIA	NaN	Cerrar fechas (bloqueo)	2022-12-30 22:03:00	NaN	NaN	NaN	2024-08-24 16:00:00	2024-08-24 11:00:00	NaN	NaN	NaN	NaN	NaN	No	NaN	No	1	Reservado	NaN	NaN	NaN	NaN
5	32489521	2022-12-30	2022-12-31	HD HUGHET	NaN	Cerrar fechas (bloqueo)	2022-12-30 22:02:00	NaN	NaN	NaN	2024-08-24 16:00:00	2024-08-24 11:00:00	NaN	NaN	NaN	NaN	NaN	No	NaN	No	1	Reservado	NaN	NaN	NaN	NaN
6	32489518	2022-12-30	2022-12-31	HD GLORIA	NaN	Cerrar fechas (bloqueo)	2022-12-30 22:02:00	NaN	NaN	NaN	2024-08-24 16:00:00	2024-08-24 11:00:00	NaN	NaN	NaN	NaN	NaN	No	NaN	No	1	Reservado	NaN	NaN	NaN	NaN
7	32489503	2022-12-30	2022-12-31	HD FIDEL	NaN	Cerrar fechas (bloqueo)	2022-12-30 22:02:00	NaN	NaN	NaN	2024-08-24 16:00:00	2024-08-24 11:00:00	NaN	NaN	NaN	NaN	NaN	No	NaN	No	1	Reservado	NaN	NaN	NaN	NaN
8	32489473	2022-12-30	2022-12-31	HD DARIO	NaN	Cerrar fechas (bloqueo)	2022-12-30 22:01:00	NaN	NaN	NaN	2024-08-24 16:00:00	2024-08-24 11:00:00	NaN	NaN	NaN	NaN	NaN	No	NaN	No	1	Reservado	NaN	NaN	NaN	NaN
9	32489449	2022-12-30	2022-12-31	HD CELESTE	NaN	Cerrar fechas (bloqueo)	2022-12-30 22:00:00	NaN	NaN	NaN	2024-08-24 16:00:00	2024-08-24 11:00:00	NaN	NaN	NaN	NaN	NaN	No	NaN	No	1	Reservado	NaN	NaN	NaN	NaN

	Posición	Llegada	Salida	Apartamento	Huésped	Portal de reserva	Creado	Email	Teléfono	Dirección	Adultos	Niños	Check-in	Check-out	Notas	Precio	Detalles de precios	Comisión incluida	City tax	Pagado	Pago por adelantado	Adelanto ya pagado	Número de noches	Estado	Nota para colaboradores	Numero_Reserva	Mensaje_Huesped	BOOKING_NOTE	Numero_Huespedes
15702	49003082	2023-12-26	2024-05-01	HD BRUNO	Cristina Maldonado	Booking.com	2023-12-11 23:56:00	cmaldo.123819@guest.booking.com	+34 648 11 83 53	NaN	2.0	1.0	2024-08-24 16:00:00	2024-08-24 11:00:00	Número de reserva: 4002704862\nMensaje del huésped: THIS RESERVATION HAS BEEN PRE-PAID BOOKING NOTE : Payment charge is EUR 13.98782\n\nDirección: Gh\nES\nMás información: booker_is_genius\nPago por adelantado: 1271.62EUR	1271.62	IVA - EUR 115.6	190.74	NaN	Sí	NaN	No	10	Reservado	NaN	4002704862		Payment charge is EUR 13.98782	3.0
15703	48800213	2024-03-02	2024-05-02	H BMA AMSTERDAM	Noemi Espinosa	Booking.com	2023-08-11 16:16:00	nespin.215286@guest.booking.com	+44 7426761457	NaN	6.0	2.0	2024-08-24 16:00:00	2024-08-24 11:00:00	Número de reserva: 4202562635\nMensaje del huésped: THIS RESERVATION HAS BEEN PRE-PAID BOOKING NOTE : Payment charge is EUR 6.0335\n\nMás información: booker_is_genius\nPago por adelantado: 548.50EUR	548.50	TVA - EUR 49.86	82.28	NaN	Sí	NaN	No	2	Cancelado	NaN	4202562635		Payment charge is EUR 6.0335	8.0
15704	48681794	2024-01-26	2024-01-28	H BMA BERLIN	Alicia Solis Picatto	Booking.com	2023-06-11 12:50:00	apicat.578133@guest.booking.com	+34 684 62 58 24	NaN	6.0	0.0	2024-08-24 16:00:00	2024-08-24 11:00:00	Número de reserva: 4128424493\nMensaje del huésped: THIS RESERVATION HAS BEEN PRE-PAID BOOKING NOTE : Payment charge is EUR 5.104\n\nDirección: Arturo Alvarez Buylla n4 6B\nOviedo\nES\nMás información: booker_is_genius\nPago por adelantado: 464.00EUR	464.00	TVA - EUR 42.18	69.60	NaN	Sí	NaN	No	2	Reservado	NaN	4128424493		Payment charge is EUR 5.104	6.0
15705	48218090	2024-02-25	2024-02-26	H BMA MONACO	José luis ruiz martinez	Booking.com	2023-10-27 14:42:00	ndqjfx.980350@guest.booking.com	+34 627 23 87 92	NaN	2.0	2.0	NaT	NaT	Número de reserva: 4254973846\nMensaje del huésped: THIS RESERVATION HAS BEEN PRE-PAID BOOKING NOTE : Payment charge is EUR 0.891 Approximate time of arrival: between 11:00 and 12:00\n\nMás información: booker_is_genius\nPago por adelantado: 81.00EUR	81.00	TVA - EUR 7.36	12.15	NaN	Sí	NaN	No	1	Reservado	NaN	4254973846	Approximate time of arrival: between 11:00 and 12:00	Payment charge is EUR 0.891	4.0
15706	48179030	2024-01-22	2024-01-24	HG1 ARTXANDA	Jorge Rubio Alcaraz	Airbnb	2023-10-26 18:05:00	NaN	34666007165	NaN	7.0	0.0	2024-08-24 16:00:00	2024-08-24 11:00:00	Número de reserva: HME2B4WMFN\nIdioma del huésped: es	327.80	Cancellation Host Fee - EUR 44.7\nCancellation Payout - EUR 283.1	44.70	NaN	No	NaN	No	2	Cancelado	NaN	NaN	NaN	NaN	7.0
15707	48020365	2024-06-17	2024-06-21	H - BUA 3P	Navarra Adentro	Reserva directa	2023-10-23 12:17:00	NaN	659636268	NaN	1.0	0.0	2024-08-24 16:00:00	2024-08-24 11:00:00	Viene con un grupo del hostel.	520.00	NaN	NaN	NaN	No	NaN	No	4	Reservado	NaN	NaN	NaN	NaN	1.0
15708	46670629	2024-11-02	2024-12-02	H BMA AMSTERDAM	Crespi Catalina	Booking.com	2023-09-26 14:51:00	ccatal.288618@guest.booking.com	+34 617 49 18 56	NaN	7.0	0.0	2024-08-24 16:00:00	2024-08-24 11:00:00	Número de reserva: 4232587055\nMensaje del huésped: THIS RESERVATION HAS BEEN PRE-PAID BOOKING NOTE : Payment charge is EUR 1.75175\n\nMás información: booker_is_genius\nPago por adelantado: 159.25EUR	159.25	TVA - EUR 14.48	23.89	NaN	Sí	NaN	No	1	Cancelado	NaN	4232587055		Payment charge is EUR 1.75175	7.0
15709	46642321	2024-12-01	2024-01-14	H BMA BERLIN	Mikel Zugasti Rezola	Booking.com	2023-09-25 23:26:00	mrezol.585471@guest.booking.com	+34 666 22 54 76	NaN	6.0	0.0	2024-08-24 16:00:00	2024-08-24 11:00:00	Número de reserva: 4237415932\nMensaje del huésped: THIS RESERVATION HAS BEEN PRE-PAID Approximate time of arrival: between 17:00 and 18:00 BOOKING NOTE : Payment charge is EUR 13.1274\n\nMás información: booker_is_genius\nPago por adelantado: 1193.40EUR	521.60	TVA - EUR 47.42	78.24	NaN	Sí	NaN	No	2	Cancelado	NaN	4237415932		Payment charge is EUR 13.1274	6.0
15710	46642318	2024-12-01	2024-01-14	H BMA AMSTERDAM	Mikel Zugasti Rezola	Booking.com	2023-09-25 23:26:00	mrezol.585471@guest.booking.com	+34 666 22 54 76	NaN	5.0	0.0	2024-08-24 16:00:00	2024-08-24 11:00:00	Número de reserva: 4237415932\nMensaje del huésped: THIS RESERVATION HAS BEEN PRE-PAID Approximate time of arrival: between 17:00 and 18:00 BOOKING NOTE : Payment charge is EUR 13.1274\n\nMás información: booker_is_genius\nPago por adelantado: 1193.40EUR	671.80	TVA - EUR 61.07	100.77	NaN	Sí	NaN	No	2	Cancelado	NaN	4237415932		Payment charge is EUR 13.1274	5.0
15711	45005552	2024-08-01	2024-10-01	HG0 MUGARRA	Roxana Palala Méndez	Airbnb	2023-08-26 11:09:00	NaN	50255354808	NaN	7.0	0.0	2024-08-24 16:00:00	2024-08-24 11:00:00	Número de reserva: HM9ENYC99S\nIdioma del huésped: en	261.80	Cancellation Host Fee - EUR 35.7\nCancellation Payout - EUR 226.1	35.70	NaN	Sí	NaN	No	2	Reservado	NaN	NaN	NaN	NaN	7.0

Most frequently occurring

	Posición	Llegada	Salida	Apartamento	Huésped	Portal de reserva	Creado	Email	Teléfono	Adultos	Niños	Check-in	Check-out	Notas	Precio	Detalles de precios	Comisión incluida	Pagado	Pago por adelantado	Adelanto ya pagado	Número de noches	Estado	Nota para colaboradores	Numero_Reserva	Mensaje_Huesped	BOOKING_NOTE	Numero_Huespedes	# duplicates
0	29995319	2022-12-29	2023-05-01	H BMA OSLO	Johannes Schmid	Airbnb	2022-10-22 16:02:00	NaN	491703538486	2.0	0.0	NaT	NaT	Número de reserva: HMDEHF2TH3\nIdioma del huésped: de	1021.90	Cancellation Host Fee - EUR 153.29\nCancellation Payout - EUR 868.61\nSecurity Price - EUR 1500	153.29	Sí	NaN	No	7	Reservado	NaN	NaN	NaN	NaN	2.0	2
1	31968127	2022-12-28	2023-07-01	H BMA DUBLIN	NaN	Cerrar fechas (bloqueo)	2022-12-15 12:46:00	NaN	NaN	0.0	0.0	NaT	NaT	NaN	NaN	NaN	NaN	No	NaN	No	10	Cancelado	NaN	NaN	NaN	NaN	0.0	2
2	32169718	2022-12-30	2023-05-01	H - BUA 4P	NaN	Cerrar fechas (bloqueo)	2022-12-21 12:07:00	NaN	NaN	0.0	0.0	2024-08-24 16:00:00	2024-08-24 11:00:00	NaN	NaN	NaN	NaN	No	NaN	No	6	Reservado	NaN	NaN	NaN	NaN	0.0	2
3	32469028	2022-12-31	2023-04-01	H BMA GARAJE	luis	Reserva directa	2022-12-30 12:50:00	NaN	NaN	0.0	0.0	NaT	NaT	NaN	NaN	NaN	NaN	No	NaN	No	4	Reservado	NaN	NaN	NaN	NaN	0.0	2
4	33796325	2023-02-24	2023-02-26	H BMA MONACO	Sara Rodriguez Carvalho	Booking.com	2023-01-25 00:44:00	scarva.107440@guest.booking.com	+351 964 835 713	4.0	0.0	NaT	NaT	Número de reserva: 3930128015\nMensaje del huésped: THIS RESERVATION HAS BEEN PRE-PAID BOOKING NOTE : Payment charge is EUR 6.523 Approximate time of arrival: between 00:00 and 01:00 the next day\n\nMás información: booker_is_genius\nPago por adelantado: 593.00EUR	265.00	TVA - EUR 24.09	39.75	Sí	NaN	No	2	Reservado	NaN	3930128015	Approximate time of arrival: between 00:00 and 01:00 the next day	Payment charge is EUR 6.523	4.0	2
5	38091838	2023-05-20	2023-05-21	HD ELENA	Marina Losa Picornell	Booking.com	2023-04-16 22:19:00	jgarau.803545@guest.booking.com	+34 675 15 42 85	6.0	0.0	2024-08-24 16:00:00	2024-08-24 11:00:00	Número de reserva: 2795551840\nMensaje del huésped: THIS RESERVATION HAS BEEN PRE-PAID BOOKING NOTE : Payment charge is EUR 4.99895\n\nMás información: booker_is_genius\nPago por adelantado: 454.45EUR	257.35	IVA - EUR 23.4	38.60	Sí	NaN	No	1	Cancelado	NaN	2795551840		Payment charge is EUR 4.99895	6.0	2
6	49003082	2023-12-26	2024-05-01	HD BRUNO	Cristina Maldonado	Booking.com	2023-12-11 23:56:00	cmaldo.123819@guest.booking.com	+34 648 11 83 53	2.0	1.0	2024-08-24 16:00:00	2024-08-24 11:00:00	Número de reserva: 4002704862\nMensaje del huésped: THIS RESERVATION HAS BEEN PRE-PAID BOOKING NOTE : Payment charge is EUR 13.98782\n\nDirección: Gh\nES\nMás información: booker_is_genius\nPago por adelantado: 1271.62EUR	1271.62	IVA - EUR 115.6	190.74	Sí	NaN	No	10	Reservado	NaN	4002704862		Payment charge is EUR 13.98782	3.0	2
7	49082867	2023-12-26	2024-05-01	HD-GARAJE 5	bruno	Reserva directa	2023-11-14 14:49:00	NaN	NaN	0.0	0.0	NaT	NaT	tarjeta el 14-11	200.00	NaN	NaN	No	NaN	No	10	Reservado	NaN	NaN	NaN	NaN	0.0	2
8	49378100	2023-12-31	2024-02-01	HD ELENA	Llorian Alvarez Martinez	Airbnb	2023-11-20 20:28:00	NaN	34644263765	6.0	0.0	2024-08-24 16:00:00	2024-08-24 11:00:00	Número de reserva: HMAYKBSY9W\nIdioma del huésped: es	571.00	Cancellation Host Fee - EUR 85.65\nCancellation Payout - EUR 485.35\nSecurity Price - EUR 1500	85.65	Sí	NaN	No	2	Reservado	NaN	NaN	NaN	NaN	6.0	2
9	49787999	2023-05-12	2024-05-02	HD ALEJANDRA	Shirly a confirmar	Reserva directa	2023-11-29 16:26:00	NaN	NaN	0.0	0.0	2024-08-24 16:00:00	2024-08-24 11:00:00	NaN	7847.60	NaN	NaN	No	NaN	No	62	Cancelado	NaN	NaN	NaN	NaN	0.0	2

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)